<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_favourable_activity`;");
E_C("CREATE TABLE `ecs_favourable_activity` (
  `act_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `act_name` varchar(255) NOT NULL,
  `start_time` int(10) unsigned NOT NULL,
  `end_time` int(10) unsigned NOT NULL,
  `user_rank` varchar(255) NOT NULL,
  `act_range` tinyint(3) unsigned NOT NULL,
  `act_range_ext` varchar(255) NOT NULL,
  `min_amount` decimal(10,2) unsigned NOT NULL,
  `max_amount` decimal(10,2) unsigned NOT NULL,
  `act_type` tinyint(3) unsigned NOT NULL,
  `act_type_ext` decimal(10,2) unsigned NOT NULL,
  `gift` text NOT NULL,
  `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '50',
  `supplier_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '店铺id',
  `logo` varchar(255) NOT NULL COMMENT '活动代表图',
  PRIMARY KEY (`act_id`),
  KEY `act_name` (`act_name`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_favourable_activity` values('6','店铺全场满300元打9折','1410278400','1442160000','0,4,3','0','','300.00','0.00','2','90.00','a:0:{}','50','1','');");
E_D("replace into `ecs_favourable_activity` values('8','满500元打85折','1409500800','1443542400','0,4,3','1','8','500.00','799.00','2','85.00','a:0:{}','1','0','');");
E_D("replace into `ecs_favourable_activity` values('13','满800元打75折','1409500800','1537632000','0,4,3','0','','800.00','0.00','2','75.00','a:0:{}','2','0','/data/favourable_action_pic/supplier0/original0_13_370x200.jpg');");
E_D("replace into `ecs_favourable_activity` values('14','满赠','1411574400','1443456000','0,3','0','','500.00','0.00','0','1.00','a:2:{i:0;a:3:{s:2:\"id\";s:1:\"1\";s:4:\"name\";s:20:\"68测试示范商品\";s:5:\"price\";s:2:\"10\";}i:1;a:3:{s:2:\"id\";s:1:\"2\";s:4:\"name\";s:80:\"水清梦兰 2014秋季女装新款修身纯色棉麻防嗮宽松长袖衬衫女\";s:5:\"price\";s:1:\"0\";}}','50','0','/data/favourable_action_pic/supplier0/original0_14_370x200.jpg');");
E_D("replace into `ecs_favourable_activity` values('15','满减','1411574400','1411920000','0,4,3','0','','700.00','0.00','1','20.00','a:0:{}','50','0','/data/favourable_action_pic/supplier0/original0_15_370x200.jpg');");
E_D("replace into `ecs_favourable_activity` values('16','店铺买赠','1411488000','1443715200','0,4,3','0','','800.00','0.00','0','1.00','a:2:{i:0;a:3:{s:2:\"id\";s:3:\"162\";s:4:\"name\";s:6:\"女装\";s:5:\"price\";s:2:\"10\";}i:1;a:3:{s:2:\"id\";s:3:\"163\";s:4:\"name\";s:18:\"店铺商品测试\";s:5:\"price\";s:1:\"0\";}}','50','1','/data/favourable_action_pic/supplier1/original1_16_370x200.jpg');");
E_D("replace into `ecs_favourable_activity` values('17','满赠2','1410883200','1443715200','0,4,3','0','','600.00','0.00','0','0.00','a:2:{i:0;a:3:{s:2:\"id\";s:2:\"20\";s:4:\"name\";s:64:\"[LONGCHAMP]Le Pliage 折叠包系列长柄大号购物袋1899089\";s:5:\"price\";s:1:\"5\";}i:1;a:3:{s:2:\"id\";s:2:\"21\";s:4:\"name\";s:81:\"Party Star伏特加果冻酒 酒精果冻鸡尾酒调酒 12颗礼盒装6个口味\";s:5:\"price\";s:1:\"0\";}}','50','0','/data/favourable_action_pic/supplier0/original0_17_370x200.jpg');");
E_D("replace into `ecs_favourable_activity` values('18','儿童节','1415289600','1415548800','3','1','12,18','0.00','0.00','0','0.00','a:0:{}','50','1','/data/favourable_action_pic/supplier1/original1_18_370x200.jpg');");
E_D("replace into `ecs_favourable_activity` values('20','优惠','1418227200','1418486400','0,4,3','3','178','0.00','0.00','0','0.00','a:0:{}','50','19','/data/favourable_action_pic/supplier19/original19_20_370x200.jpg');");

require("../../inc/footer.php");
?>